Release 10.1A: OpenEdge Data Management:
SQL Reference

Compliance with industry standards

Table 69 provides details on SQL DDL and DML compliance with industry standards. A check mark indicates compliance.

Table 69: Compliance of SQL DDL and DML statements

	SQL	ODBC SQL grammar	Progress extension	Notes
BEGIN-END DECLARE SECTION	÷	–	–	Compliant if C language types used Embedded SQL only.
CLOSE	÷	–	–	Embedded SQL only.
DECLARE CURSOR	÷	–	prepared_stmt_name	Embedded SQL only.
DESCRIBE	÷	–	–	Embedded SQL only.
EXEC SQL	÷	–	–	Embedded SQL only.
EXECUTE	÷	–	–	Embedded SQL only.
EXECUTE IMMEDIATE	÷	–	–	Embedded SQL only.
FETCH	÷	–	USING DESCRIPTOR	Embedded SQL only.
GET DIAGNOSTICS	–	–	÷	Embedded SQL only.
OPEN	÷	–	USING DESCRIPTOR	Embedded SQL only.
PREPARE	÷	–	–	Embedded SQL only.
ROLLBACK	÷	–	–	–
SELECT	÷	Extended	FOR UPDATE	–
WHENEVER	÷	–	SQLWARNING STOP ACTION	Embedded SQL only.